MacWorld 1998 January/Macworld (1998-01).dmg/FileMaker Pro 4/FM4 Templates w⁄data/Home/Check Tracker

FileMaker Pro Database | 1997-09-14 | 97KB | 679 lines

    G\9|
HBAM2016AUG95
Pro 3.0
(1rpu
N@%Ia
PXEpH\
,X|%{
UFDgc
/__Mw
HBAM3016AUG95@
HP DeskJet 540 Printer
Pro 2.0 - 2.1F!
Pro 3.0
o 3.0
AMNT CREDIT
AMNT DEBIT
AMOUNT
BAL RUNNING
CLEARED
CREATED BY
DATE CLEARED
DATE MODIFIED
DESCRIPTION
PAID TO_OR FROM
STATE
STREET
TRANS DATE
TRANS NUMBER
TTL AMNT CRED
TTL AMNT DEB
TTL AMOUNT
ZIP CODE
US English - Spelling
Franz User Dictionary
    USENG.NDX
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
12/8/95
Trans NumberB
Date ModifiedB
Paid To_or FromB
Trans DateB
DescriptionB
Amnt CreditB
ClearedB
_m000011B
 100))
_m000100B
 1000) / 100)
_m011000011000011000m011000m011000m011000m011000m011000m011000m011000m011000
Description
This is a simple solution to record debits from and credits to a checking account.
The Transaction List report calculates your running balance.
How to use this solution
Enter all your transactions as you write checks and withdraw or deposit money.  Include the check number or transaction number in the Ref. No. field as a reference.
How to customize this solution
Add a new field called Category. Then, you can design a report that breaks down your financial transactions bB
y category, so that you know where your money goes each month. See the documentation on Sub-summary reports for more information.
sign the check printing layout to fit the design of your tractor feed checks.
@@BA@
bRBBP0
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
AD@D@
AD@D@
"%UR
UD33D
Amnt DebitB
AmountB
Ttl Amnt DebB
Ttl Amnt CredB
Ttl AmountB
Bal RunningB
StreetB
CityB
StateB
ZIP CodeB
Date ClearedB
InfoB
Created ByB
Created ByB
Created ByB
StateB
ZIP CodeB
Date ClearedB
InfoB
Created ByB
"B    A    Form View
A    List View
Transaction List
Information
Report Menu
A    Form ViewB
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
A    List ViewB
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Date Cleared
ZIP Code
Payee Address
Description
Deposit or Credit
Withdrawal or Debit
Paid To or From
Ref. No.
Enter data for Transactions
Check Tracker
Transaction ListB
Your Own
Buttonb
Your Own
Buttonc
Recordd
Delete
Recorde
Recordf
Reportsg
View As
Listh
View As
Formi
Closej
Infok
Balancel
Creditm
Debitn
Paid To or Fromo
Datep
Ref No.q/Click to see more information for a Transaction
InformationB
Your Own
Button
Reports
View As
View As
Close
Paid To or From
Ref. No.
Balance
Debit
Credit
Page ##
Transaction List
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO,Information about the Check Tracker solutionP
Info for this Solution
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
InfoG
Your Own
ReportH
Your Own
ReportJ
Transaction ListK>Click on any of these buttons to preview the respective reportL
Select a reportM
Your Own
Report
ReportH
Your Own
ReportJ
Transaction ListK>Click on any of these buttons to preview the respective reportL
Select a report
Print CheckB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
09/29/95
06/01/95
Beginning Balance
Cleared
09/29/95
The Gas Company
06/02/95
Gas & electric bill
66.45
-66.45
    Box 52001
San Francisco
94152-0002
09/29/95
The Phone Company
06/03/95
Telephone bill
Twoill
TwoOne
TwoOne
TwoOne
TwoOne
TwoOne
Twone
Twone
Twone
TwoOne
TwoOne
TwoOne
TwoOne
TwoOne
Twone
Twone
Twone
TwoTwo
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
    ffffff
UUUUUU
DDDDDD
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
850.31
5399.69
5000C
4933.55D
4899.69E
4149.69F
5399.69
33.86
-33.86
10/01/95
Landlord
06/07/95
09/29/95
Employer
06/15/95
Deposit Paycheck
Foure
Fourq
Fourq
Fourhree
Fouraycheck
Three
Fourne
Three
Fourne
Three
Fourwo
Three
Fouree
FourThree
Fourhree
Fourree
Fourree
Fourhree
Fouree
Fouree
Fouree
Fourree
Fourree
FourThree
Fourhree
FourThree
Fourree
Fourree
Fourhree
Fourhree
Fouree
Fouree
Fourq
Foure
Foure
Fourq
Foure
Fourq
Fourq
FourFourFourFour
Fourhree
Fourk
Three
Fourq
Fouro
Three
Fouro
Three
Fouro
Three
FourThree
Fourhree
Fourree
Fourree
Fourhree
Fouree
Fouree
Fouree
Fourree
Fourree
FourThree
Fourhree
FourThree
Fourree
Fourree
Fourhree
Fourhree
Fouree
Fouree
Fourq
Foure
Foure
Fourq
Foure
Sort by Date
Sort by Transaction Number
Sort by Paid To
Transaction List
Open Script
Sort by Date
Sort by Transaction Number
Sort by Paid To
Transaction List
Open Script
UUUUUU
wwwwww
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA
Cleared
VDEFA(
Cleared List
UUUUU
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww